CREATE TABLE [dbo].[PublishRequestDetail]
(
[PublishRequestDetailKey] [uniqueidentifier] NOT NULL,
[PublishRequestKey] [uniqueidentifier] NOT NULL,
[PublishRequestStatusCode] [int] NOT NULL,
[PublishServerCode] [nchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Frequency] [int] NOT NULL,
[IsRegenerate] [bit] NOT NULL,
[IsDelete] [bit] NOT NULL,
[NumOfAttempts] [int] NOT NULL,
[PublishedDateTime] [datetime] NULL,
[ContentDocumentKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PublishRequestDetail] ADD CONSTRAINT [PK_PublishRequestDetail] PRIMARY KEY CLUSTERED ([PublishRequestDetailKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishRequestDetail_ContentDocumentKey] ON [dbo].[PublishRequestDetail] ([ContentDocumentKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishRequestDetail_PublishRequestKey] ON [dbo].[PublishRequestDetail] ([PublishRequestKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishRequestDetail_PublishRequestStatusCode] ON [dbo].[PublishRequestDetail] ([PublishRequestStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishRequestDetail_PublishServerCode] ON [dbo].[PublishRequestDetail] ([PublishServerCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PublishRequestDetail] ADD CONSTRAINT [FK_PublishRequestDetail_ContentDocumentKey] FOREIGN KEY ([ContentDocumentKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey])
GO
ALTER TABLE [dbo].[PublishRequestDetail] ADD CONSTRAINT [FK_PublishRequestDetail_PublishRequest] FOREIGN KEY ([PublishRequestKey]) REFERENCES [dbo].[PublishRequest] ([PublishRequestKey]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PublishRequestDetail] ADD CONSTRAINT [FK_PublishRequestDetail_PublishRequestStatusRef] FOREIGN KEY ([PublishRequestStatusCode]) REFERENCES [dbo].[PublishRequestStatusRef] ([PublishRequestStatusCode])
GO
ALTER TABLE [dbo].[PublishRequestDetail] ADD CONSTRAINT [FK_PublishRequestDetail_PublishServerRef] FOREIGN KEY ([PublishServerCode]) REFERENCES [dbo].[PublishServerRef] ([PublishServerCode]) ON DELETE CASCADE
GO